ds=$1

sqoop import \
--delete-target-dir \
--connect jdbc:mysql://master:3306/yhhx \
--username root \
--password '123456' \
--query "select * from t_commodity where  \$CONDITIONS" \
--target-dir /daas/motl/bigdata01/yhhx/ods/ods_t_commodity/ds=$ds \
--fields-terminated-by ',' \
-m 1

hive -e "alter table bigdata01_ods.ods_t_commodity  add if not exists partition(ds='$ds');"